This code will help produce the three visuals that are going to be a
part of each equity tracker indicator webpage: regional map (tract
level) of most recent data, chart of the most recent data, chart of
trends over time.
If the indicator is a PUMS/OPSI indicator that can be accessed
through Elmer. Getting the data to a workable version may
require some data transformation. To explore, clean, transform, and
generate a final data set, please use the
data-gen-pums-template. This script will generate an .rda for
the map and an .rda for the charts. These data sets will be loaded in
before the data visualization code.
[Please include the following for a general, layperson audience: 1-2 sentences explaining what your indicator is/measures, what it says about people’s life outcomes; 1 sentence describing why it is useful/relevant in the indicator’s theme]
To map data in this form, it requires accessing data at the regional/tract level from ACS since the Elmer data set is already aggregated to equity group/quintile.
Source(s): U.S. Census Bureau, 2018-2022 American Community Survey 5-Year Estimates, Table S2201; U.S. Census Bureau, Geography Division 2020 TIGER/Line Shapefiles
Kindergarten Readiness by Community
Percent of students demonstrating readiness in 6 of 6 domains*
Washington Office of Superintendent of Public Instruction, Report Card
WaKids 2022-23 School Year, Washington Kindergarten Inventory of
Developing Skills
*Social-Emotional, Physical, Language, Cognitive,
Literacy, and Math
Kindergarten Readiness Trend by Community
Percent of students demonstrating readiness in 6 of 6 domains*, in 1-year spans between 2010 and 2022
Washington Office of Superintendent of Public Instruction, Report Card
WaKids 2010-23 School Year, Washington Kindergarten Inventory of
Developing Skills
Limited data available for students in Kitsap
County
No data available for school year 2020-21
*Social-Emotional, Physical, Language, Cognitive, Literacy, and Math
This step will transfer all of the Rmd output files (html and docx) to the network for review. It will keep the Rmd files within GitHub so that code is kept in a central place.
This step will transfer the previous data and files to the archive folder. This step is meant to retain the older versions in case they are needed for reference.
This step will clean the indicator folder to make room for the new versions.
Once the data and planning reviews are complete, this step will move all of the updated data/files to the general indicator folder. They should be moved from the update (draft staging directory) to the parent folder so that the htmls can be copied to the webpage folder (outside the firewall).
This step will help keep the folders organized and ready for the next update.
This step copies the htmls for the webpage (3 visuals) from the network to the folder outside the firewall- this ‘external’ folder connects directly to the webpage.